MS SQL connector

Supported versions

Microsoft SQL Server 2019

Supported data types

The following are the different data types that are tested in our lab setup:

  • VARCHAR

  • CHAR

  • DATETIME

  • INT

  • TEXT

  • VARBINARY (only unload/load)

  • SMALLINT

  • SMALLMONEY

  • MONEY

  • BIGINT

  • NVARCHAR

  • TINYINT

  • NUMERIC(X,Y)

  • DECIMAL(X,Y)

  • FLOAT

  • NCHAR

  • BIT

  • NTEXT

  • MONEY

  • Structured data types:

    • XML

    • JSON

Property values

Property

Value

SKIP.LOAD.SPLIT.COUNT.VALIDATION

false

SKIP.UNLOAD.SPLIT.COUNT.VALIDATION

false

For default values, see Configuration settings

Known limitations

  • If the applied algorithm's produced mask data exceeds the corresponding target table columns datatype's max value range, then job execution will fail in load service.

  • Schemas, tables, and column names having special characters are not supported.

  • Masking of columns with VARBINARY datatype is not supported.

  • Hyperscale Compliance can mask up to a maximum 1000 tables in a single job.